package com.nado.iims2.blog.dao.service;

import java.sql.SQLException;
import java.util.List;

import com.nado.iims2.blog.model.service.Banner;
import com.nado.iims2.blog.model.service.BannerThema;

public interface BannerDAO {
	/**
	 * Select banner thema list.
	 * 
	 * @return
	 * @throws SQLException
	 */
	List<BannerThema> selectBannerThemaList() throws SQLException;
	
	/**
	 * Select banner thema info.
	 * 
	 * @param bnnrThmSeq 배너 테마 번호
	 * @return
	 * @throws SQLException
	 */
	BannerThema selectBannerThemaByNo(int bnnrThmSeq) throws SQLException;
	
	/**
	 * Select banner list.
	 * 
	 * @param bnnrThmSeq 배너 테마 번호
	 * @param progressYn 진행중인 배너
	 * @param offset
	 * @param count
	 * @return
	 * @throws SQLException
	 */
	List<Banner> selectBannerList(int bnnrThmSeq, String progressYn, int offset, int count) throws SQLException;
	
	/**
	 * Select banner list count.
	 * 
	 * @param bnnrThmSeq 배너 테마 번호
	 * @param progressYn 진행중인 배너
	 * @return
	 * @throws SQLException
	 */
	int selectBannerListCount(int bnnrThmSeq, String progressYn) throws SQLException;
	
	/**
	 * Select banner detail info.
	 * 
	 * @param bnnrSeq 배너번호
	 * @return
	 * @throws SQLException
	 */
	Banner selectBannerDetail(int bnnrSeq) throws SQLException;
	
	/**
	 * Select banner order list.
	 * 
	 * @param bnnrThmSeq 배너테마번호
	 * @return
	 * @throws SQLException
	 */
	List<Banner> selectBannerOrderList(int bnnrThmSeq) throws SQLException;
	
	/**
	 * Select max banner order number.
	 * 
	 * @param bnnrThmSeq 배너테마번호
	 * @return
	 * @throws SQLException
	 */
	int selectMaxBannerOrder(int bnnrThmSeq) throws SQLException;
}
